Request Employee Data

This option allows the user to obtain a spreadhseet containing employee information for a particular Company Code, Line of Business, Division, Location, SBU, Team.

Go to HR Reports/Request Employee Data. Click on 'By HR structure' or 'By Operations structure'.
Select a time period for the report using the Pay Period End field. The field defaults to the most current pay period. This selection allows you to pull reports according to the following time frames; This week, Last week, This pay period, Last Pay period, This month and Last month.
Include Active, Terminated or All Employees using the Employee Status drop down list.
User may filter report by setting a particular Business Group, Company Code, etc. drop down boxes. (setting fields to 'All' will return all entries in the database for that level of the hierarchy.)
Select the data elements to be included by using the checkboxes in the Data To Be Exported section.
- Basic Employee Data includes:
  - Employee ID
  - WIN
  - Employee Name
  - Region Code and region name
  - Country Code and country name
  - (FEPS) Company Code
  - (FEPS) Division
  - (FEPS) SBU ID
  - (FEPS) Location
  - (FEPS) Team
  - Employee has a picture
  - Status
  - Email Address
- General Employee Data: All of the Basic Employee Data plus:
  - Company
  - Business Group
  - Business Unit
  - Line of Business
  - SBU Client
  - Entity Code
  - Location Code
  - Location Description
  - Department Code
  - Cost Center (GL Account Number)
  - Job Code
  - Job Title
  - Job Tier
  - Job Family
  - Alternate Job Title
  - Hire Date
- Employee Payroll Data: All of the Basic Employee Data plus:
  - Shift
  - Full/Part-Time
  - Pay Type
  - Salary
  - Hourly Rate
  - 99 Rate
  - Subsidy Rate
  - PTO Rate
  - Shift Differential
  - Sunday Normal
  - Hire Type
  - OT Calc Method
  - Direct/Indirect
  - Daily Minimum
  - Daily, Minimum Hours
  - Work Location
  - Supervisor Id
  - Supervisor WIN
  - Supervisor First Name
  - Supervisor Last Name
  - Category
  - Seniority
  - Regular Clock in
  - Regular Clock out
  - Allow Time Clock
  - MT Hours Offset.
- Employee Comp & Review: All of the Basic Employee Data plus:
  - Last Review Date
  - Performance Rating
  - Next Review Date
  - Last Promotion
  - Annual Salary
  - Annual Salary USD
  - Salary Change %
  - Previous Salary
  - Salary Change Amount
  - Salary Change Effective Date
  - Salary Change Reason
- Include Bonus Plan Detail: All of the Basic Employee Data and Employee Comp & Review Data plus:
  - Bonus Plan Start Date
  - Bonus Plan Pay Frequency
  - Bonus Plan %
  - Bonus Plan Amount for up to seven bonus plan/pay frequency combinations
User may click on the employee names formatted using the check box selections under the Format Employee Name as field.
Use the 'Return email address' field to confirm the email address where the report will be sent.
Click on Submit.
The user will receive an email message containing the requested report, which can be open as an Excel file.